﻿

--drop table PomPropertyImagesDeleted
Create TABLE PomPropertyImagesDeleted
(
	[PomPropertyImagesID] INT NOT NULL,
	[PomplingAddressID] INT NOT NULL,
	[DisplayPicturePath] VARCHAR(100),
	[PomplingCustomerID] varchar(32) NOT NULL CONSTRAiNT  [FK_PomPropertyImagesDeleted_PomplingCustomers_PomplingCustomerID] FOREIGN KEY REFERENCES PomPomplingCustomers([PomplingCustomerID]),
	[PictureTitle] VARCHAR(100), 
	[IsDeleted] bit default 0,
	[DeletedDate] SMALLDATETIME DEFAULT GETDATE(),
	 CONSTRAINT [PK_PomPropertyImagesDeleted_PropertiesAdditionalImageID] PRIMARY KEY CLUSTERED ([PomPropertyImagesID] ASC)
)

GO

